2013-07-25 - 8216 - Enhancement - Inventory Source #InventoryManagement
ENHANCEMENT
8216 - Inventory Source
Requirement Summary
Need to change the ECC FM to extract valid season for BW extractor.
Admin Info
Purpose
|
Changing the ECC FM to extract valid season for BW extractor
|
Requested By
|
Mark Harris
|
Spec Created By
|
Krishna Sandeep G
|
Spec Created Date
|
07/25/2013
|
Spec QA by
|
Uday Kumar P
|
Objects
|
Function Modules: ZBI_GENERIC_INVEXT
ZFM_WEEKLY_ATP_UPDATE2
|
Document Status
|
Complete
|
References
Prior Tickets
8215
Documents
None
Functional Requirement
Currently in ECC Function Modules associated with the Inventory data (Daily load and Monthly load) the logic for fetching the valid season of a material is incorrect. So need to make changes to fetch the valid season based on the entries in the Condition records season determination table (/AFS/DPRG_KOND).
Below are the listed objects in which changes need to be done:
1. Changes in Monthly Inventory function module ZBI_GENERIC_INVEXT logic to fetch
valid season.
2. Changes in Daily Inventory function module to ZFM_WEEKLY_ATP_UPDATE2 logic to fetch
valid season.
3. Design a new Process Chain to automate Monthly inventory loading.
Solution Summary
1. When checked in the Function Modules, the logic to fetch the valid season for a material is incorrect. For Monthly inventory FM, it was written to fetch the first season of a material. For Daily inventory, it was hard coded to 'RES'.
2. Need to change the logic for filling the valid season of a material based on the entries maintained for a season in table '/AFS/DPRG_KOND'.
Test Plan
SNo.
|
Test Scenario
|
Expected Results
|
1
|
Assign multiple seasons for a material with one seasons valid and one season invalid.
|
The valid season should be passed to material.
|
2
|
Assign a single season for a material with valid date.
|
The valid season should be passed to material.
|
3
|
Assign a single season for a material with invalid date
|
The Season should not be passed to material.
|
4
|
Assign multiple seasons to material with one season validity in the future and the remaining invalid.
|
The valid season should be passed to material.
|
Solution Details
Need to change in the logic to fetch the valid season for a materiae as follows:
1. Fetch all the seasons and collections assigned to a material and sort the fetched entries in ascending order.
2. Fetch all the condition records maintained in the table /AFS/DPRG_KOND with inputs of above obtained seasons, collections and sales org associated to a plant.
3. From the fetched condition records remove the entries whose Customer KUNNR value is blank.
4. Loop the seasons obtained and with this season as input loop the condition records data. Check the condition value of SY-DATUM(Current system date) lies between the Order from date(J_3AUDTV) and Order to date(J_3AUDTB) dates of the condition records.
5. If this condition holds good, then pass the Season, Collection, Delivery date from and Delivery date to that material, if the load was Monthly inventory.
6. Pass Season and Collection to that material if the load was Daily inventory.
7. If the above condition fails then again loop the condition records. Check whether the value of SY-DATUM is less than the Order from(J_3AUDTV) date and pass the values once condition is satisfied.
8. If both conditions fail, then pass the blank Season, Collection, Delivery date from and Delivery date to values to material.
Issues
None